-- 应急预案
ALTER TABLE [dbo].[t_contingency_plan_resources] ALTER COLUMN [label] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    GO
ALTER TABLE [dbo].[t_contingency_plan_resources] ALTER COLUMN [label_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    GO
ALTER TABLE [dbo].[t_contingency_plan_resources] ALTER COLUMN [moid] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

ALTER TABLE [dbo].[t_contingency_plan_resources] ADD [name] nvarchar(255) NULL
    GO

ALTER TABLE [dbo].[t_contingency_plan_resources] ADD [num] nvarchar(255) NULL
    GO

ALTER TABLE [dbo].[t_contingency_plan_resources] ADD [resource] nvarchar(255) NULL
    GO

ALTER TABLE [dbo].[t_contingency_plan_resources] ADD [contact_name] nvarchar(255) NULL
    GO

ALTER TABLE [dbo].[t_contingency_plan_resources] ADD [contact] nvarchar(255) NULL
    GO

ALTER TABLE [dbo].[t_contingency_plan_resources] ADD [address] nvarchar(255) NULL
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'名称',
    'SCHEMA', N'dbo',
    'TABLE', N't_contingency_plan_resources',
    'COLUMN', N'name'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'资源数量',
    'SCHEMA', N'dbo',
    'TABLE', N't_contingency_plan_resources',
    'COLUMN', N'num'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'资源描述',
    'SCHEMA', N'dbo',
    'TABLE', N't_contingency_plan_resources',
    'COLUMN', N'resource'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'负责人',
    'SCHEMA', N'dbo',
    'TABLE', N't_contingency_plan_resources',
    'COLUMN', N'contact_name'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'联系方式',
    'SCHEMA', N'dbo',
    'TABLE', N't_contingency_plan_resources',
    'COLUMN', N'contact'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'地址',
    'SCHEMA', N'dbo',
    'TABLE', N't_contingency_plan_resources',
    'COLUMN', N'address'

-- 内涝点关联设备调整
ALTER TABLE [dbo].[t_pond_link] ALTER COLUMN [label_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

-- 预警规则详情结构调整
ALTER TABLE [dbo].[t_waring_role] ALTER COLUMN [label_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
